Excel - Import TXT File

The following is an example of how to import the THERAPY.TXT into Excel following the export of a Medication search to Tab Separated.

1. Open Excel, and select File - Open.
2. Browse to the location the files are extracted too.
   For example, c:\extract (practices with their own server) or P:\extract\YourName (hosted practices).
3. Change the file type on the bottom right, to All Files.
   The list refreshes and now displays .TXT and .DBF files.
4. Select the file, in this example, THERAPY.TXT.
   The Text Import Wizard displays.

   

5. Select Next to proceed, leaving the tick in the Delimited option.
   Step 2 displays.
6. Accept the default values for Step 2, and select Next.

   
   

   Step 3 displays.

7. The Step 3 screen lets you select any columns containing a date and set the format to Date.
   Look for the Event Date column, select and choose Date as the type.

   

8. Select Finish to proceed.
   The spreadsheet displays.